﻿CREATE TABLE [dbo].[Alert]
(
	[alert_id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [alert_rule_id] INT NOT NULL, 
    [create_date] DATETIME NOT NULL DEFAULT getutcdate(), 
    [status] TINYINT NOT NULL DEFAULT 0, 
    [entity_id] INT NOT NULL, 
    [closed_date] DATETIME NULL, 
    [entity_property_id] INT NOT NULL, 
    [alert_count] INT NOT NULL DEFAULT 1
)
